// db con.
require "administrace/req/pass.php";
require "inc/funkce.php";
/*
get page & seo params by send url
get url & page ID & META:
1) check lang by /en/ ...
2) search last part of url in db: "url" table [url,table,id,lang]
3) set page ID,table name & meta
4) add other languages url of cur. page to lang links
- generovani prazdnych cat.
- nefungujici url pro nove pr. rec.
*/
$odesilaci_hlaska_typ = "";
$conf_weby_curr_id = 1;
$lang_sql_str = '';
$dnes = date('Y-m-d'); // (5.4.) 10.4. (20.5.)
$conf_path_to_gallery = 'data/';
$conf_default_lang = 'cz';
// folders (each products have oht. pr. code)
$conf_images_folder = 'img/';
$conf_files_folder = 'file/';
// conf types
$send_url = $_SERVER['REQUEST_URI'];
// def. get params
$get_n = $get_e = $get_cms = false;
// check if url contain params (?)
$send_parms = $sql_main_get = false;
$pos = strpos($send_url, '?');
if ($pos !== false) {
$tmp_arr = explode('?',$send_url);
$send_url = trim($tmp_arr[0]);
// handle params
$send_parms = trim($tmp_arr[1]);
$params_arr = explode('&',$send_parms);
// main catogories
foreach ($params_arr as $key => $value_get) {
$value_get = urldecode($value_get);
$tmp_value_arr = explode('=',$value_get);
$value = $tmp_value_arr[1];
$key = $tmp_value_arr[0];
if ($value!='') {
// send month
if ($key=='n') {
$get_n = FixInt($value);
}
// send email verification
if ($key=='e') {
$get_e = trim($value);
}
// send cms verification
if ($key=='x') {
$get_cms = trim($value);
$get_cms = $get_cms=='947' ? true : false;
}
}
}
}
// conf types
if (substr($send_url,-1)=='/') $send_url = substr($send_url,0,-1);
$page_arr = explode('/',$send_url);
$url_pos = $page_arr[count($page_arr)-1]!='' ? 1 : 2; // detect '/' at last char
$page_link = $page_arr[count($page_arr)-$url_pos]; // detect page key
$page_lang = $page_arr[count($page_arr)-($url_pos+1)]; // detect page key
$page_id = $page_type = $page = $poi_id = $table = $title = $descr = $title_seo = $descr_seo = $page_top = $category_id = $product_id = $realizace_id = $vyrobce_id = $designer_id = $high_category = $types_id = $category_main_id = $aktuality_id = $breadcrumb = $my_weby_curr_id = $realforms = $produkt_prodejci = $division_cat_id = $products_izolace_count = $products_filtrace_count = false;
$page_url_arr = $types_arr = $types_url_arr = $pages_title_arr = $products_page_images_all_arr = $types_top_arr = $category_arr = $category_url_arr = $category_top_arr = $pages_arr = $pages_url_arr = $pages_top_arr = $produkt_arr = $data_url_arr = $menu_title_arr = $menu_url_arr = $high_category_arr = $data_typzobrazeni_arr = $pages_pcs_arr = $poi_arr = $poi_url_arr = $subpages_title_arr = $subpages_perex_arr = $subpages_text_arr = $pages_perex_arr = array();
// safe page link
$page_link = strtr($page_link,$spec_chars_arr);
$page_link = preg_replace("/[^A-Za-z0-9\.\-_\/ ]/", '', $page_link);
$page_izolace_id = 3;
$page_filtrace_id = 2;
$page_search_id = 40;
$page_news_id = 41;
$page_contact_id = 34;
$page_company_id = 24;
$page_aplication_izolace_id = 4;
$page_aplication_filtrace_id = 9;
$page_404_id = 42;
$page_form_id = 43;
// custommer sections
$conf_customer_section = array(1=>211,212,213,214,215);
$sr = isset($_POST['sr']) && $_POST['sr'] ? $_POST['sr'] : false;
$hl = strtr($sr,$spec_chars_arr);
$hl = preg_replace("/[^A-Za-z0-9\-_\/ ]/", '', $hl);
// preview from CMS
$sql_active = $get_cms ? 'active < 10' : 'active = 1'; // show all rec. if is in url &x=947
/*
----------------------------------------------------
detect domain & language
- hobra.cz - lang file with conf, names, ...
- set specific CSS, IMG, functions...
----------------------------------------------------
*/
if ($page_link=='en' || $page_lang=='en') {
$lang_sql_str = '1';
$lang = 'en';
$language_link = 'en/';
include "inc/lang-en.php";
} else if ($page_link=='de' || $page_lang=='de') {
$lang_sql_str = '2';
$lang = 'de';
$language_link = 'de/';
include "inc/lang-de.php";
} else if ($page_link=='ru' || $page_lang=='ru') {
$lang_sql_str = '3';
$lang = 'ru';
$language_link = 'ru/';
include "inc/lang-ru.php";
} else {
$lang_sql_str = '';
$lang = 'cz';
$language_link = '';
include "inc/lang-cs.php";
}
// share url
$this_url = 'https://'.$_SERVER["SERVER_NAME"].'/'.$language_link.$page_link;
/*
---------------------------
all products (except pages cat)
---------------------------
*/
$products_url_arr = $products_cat_arr = $products_foto_all_arr = $products_name_arr = $products_foto_arr = $products_perex_arr = $products_page_images_arr = $products_page_cat_arr = array();
$vysledek = Pg_Exec("SELECT pdp_products.*,pdp_products_text.preview,pdp_products_text.name,pdp_products_text.alias FROM pdp_products,pdp_products_text WHERE pdp_products.id = pdp_products_text.item AND pdp_products_text.language = '$lang' AND pdp_products.active = 1 ORDER BY pdp_products.novinkado,pdp_products.doporucujeme,pdp_products.razeni");
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
$products_url_arr[$zaznam['id']] = printSqlCol('alias',$zaznam);
$products_cat_arr[$zaznam['id']] = printSqlCol('cat',$zaznam);
$products_name_arr[$zaznam['id']] = printSqlCol('name',$zaznam);
// prepare perex
$tmp = strip_tags(printSqlCol('preview',$zaznam)).' '.strip_tags(printSqlCol('content',$zaznam));
$products_perex_arr[$zaznam['id']] = utf8_substr_word($tmp,160).'...';
// application
$products_application_arr[$zaznam['id']] = array();
if (printSqlCol('ap5',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 5;
if (printSqlCol('ap6',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 6;
if (printSqlCol('ap7',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 7;
if (printSqlCol('ap8',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 8;
if (printSqlCol('ap13',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 13;
if (printSqlCol('ap12',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 12;
if (printSqlCol('ap11',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 11;
if (printSqlCol('ap10',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 10;
if (printSqlCol('ap14',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 14;
if (printSqlCol('ap15',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 15;
if (printSqlCol('ap16',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 16;
if (printSqlCol('ap17',$zaznam)=='t') $products_application_arr[$zaznam['id']][] = 17;
// count main products
if (printSqlCol('cat',$zaznam)==3) {
$products_izolace_count++;
} else if (printSqlCol('cat',$zaznam)==2) {
$products_filtrace_count++;
}
// images
if (printSqlCol('images',$zaznam)!='') {
$tmp_arr = explode('|',printSqlCol('images',$zaznam));
$products_foto_arr[$zaznam['id']] = $tmp_arr[0];
$products_foto_all_arr[] = $tmp_arr[0];
}
}
/*
---------------------------------------------------
detect pages from url & homepage
---------------------------------------------------
*/
if ($page_link == 'hobra.cz' || $page_link == 'index.php' || $page_link == '' || $page_link=='cz' || $page_link=='en' || $page_link=='de' || $page_link=='ru') {
$page = 'homepage';
$page_url_arr = array('cz'=>$root,'en'=>$root.'en/','de'=>$root.'de/','ru'=>$root.'ru/');
$homepage_id = $page_id = 1;
// default texts for other langueges
if ($lang!='cz') {
$def_lang_pages_perex_arr = $def_lang_pages_text_arr = array();
$vysledek = Pg_Exec("SELECT item,content,preview FROM pdp_pages_text WHERE pdp_pages_text.language = 'cz'");
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
$def_lang_pages_perex_arr[$zaznam['item']] = printSqlCol('preview',$zaznam);
$def_lang_pages_text_arr[$zaznam['item']] = printSqlCol('content',$zaznam);
}
}
// homepage content
$homepage_title_arr = $homepage_text_arr = array();
$i = 0;
// for all pages read products pages for top menu (cache?)
$vysledek = Pg_Exec("SELECT pdp_pages.parentpage,pdp_pages.id AS pid,pdp_pages_text.* FROM pdp_pages,pdp_pages_text WHERE pdp_pages.id = pdp_pages_text.item AND pdp_pages_text.language = '$lang' AND pdp_pages.active = 1 ORDER BY razeni");
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
// if not set page icon use page title
$ikona_tmp = printSqlCol('icon',$zaznam);
$pages_arr[$zaznam['pid']] = $ikona_tmp!='' ? $ikona_tmp : printSqlCol('name',$zaznam);
$pages_url_arr[$zaznam['pid']] = $root.$language_link.printSqlCol('alias',$zaznam);
$pages_title_arr[$zaznam['pid']] = printSqlCol('name',$zaznam);
// prepare perex
$tmp = strip_tags(printSqlCol('preview',$zaznam)).' '.strip_tags(printSqlCol('content',$zaznam));
$pages_perex_arr[$zaznam['pid']] = utf8_substr_word($tmp,160).'...';
// if set, add link to this page as subpage
$pages_top_arr[$zaznam['pid']] = printSqlCol('parentpage',$zaznam);
// if this page == current -> set page type
if ($zaznam['pid']==$homepage_id) {
$page_type = '';
$page_top = printSqlCol('parentpage',$zaznam);
if (isset($pages_top_arr[$page_top]) && $pages_top_arr[$page_top]>0) $page_top = $pages_top_arr[$page_top];
if (!$title) $title = printSqlCol('name',$zaznam);
$perex = printSqlCol('preview',$zaznam);
$text = printSqlCol('content',$zaznam);
// found SEO data in db
$title_seo = printSqlCol('name_title',$zaznam);
$descr_seo = printSqlCol('preview_desc',$zaznam);
}
if ($zaznam['parentpage']==$homepage_id) {
$i++;
$homepage_title_arr[$i] = printSqlCol('name',$zaznam);
$homepage_text_arr[$i] = printSqlCol('content',$zaznam);
}
// products based on pages (category)
if ($zaznam['parentpage']==2 || $zaznam['parentpage']==3) {
$products_page_cat_arr[$zaznam['pid']] = printSqlCol('parentpage',$zaznam);
// images
$tmp_arr = explode('|',printSqlCol('images',$zaznam));
$products_page_images_all_arr[] = $tmp_arr[0];
$products_page_images_arr[$zaznam['pid']] = $tmp_arr[0];
// count main products
if (printSqlCol('parentpage',$zaznam)==3) {
$products_izolace_count++;
} else if (printSqlCol('parentpage',$zaznam)==2) {
$products_filtrace_count++;
}
}
}
} else {
// found url in db
$sSql = "SELECT * FROM url WHERE url$lang_sql_str='$page_link'";
$vysledek = Pg_Exec($sSql);
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
// page conf
$page = printSqlCol('url'.$lang_sql_str,$zaznam); // in other language update col_name[X]
$page_id = printSqlCol('item',$zaznam);
$table = printSqlCol('tabulka',$zaznam);
// links to other langs
$page_url_arr = array('cz'=>$root.''.printSqlCol('url',$zaznam),'en'=>$root.'en/'.printSqlCol('url1',$zaznam),'de'=>$root.'de/'.printSqlCol('url2',$zaznam),'ru'=>$root.'ru/'.printSqlCol('url3',$zaznam));
// seo for cur. page in cur. lang
$title_seo = printSqlCol('title'.$lang_sql_str,$zaznam);
$descr_seo = printSqlCol('descr'.$lang_sql_str,$zaznam);
}
/*
--------------------------------
all pages inc. category pages
--------------------------------
*/
// for all pages read products pages for top menu (cache?)
$custommer_type = false;
$vysledek = Pg_Exec("SELECT pdp_pages.realforms,pdp_pages.sellers,pdp_pages.images,pdp_pages.custommertype,pdp_pages.relatedprod,pdp_pages.files,pdp_pages.parentpage,pdp_pages.id AS pid,pdp_pages_text.* FROM pdp_pages,pdp_pages_text WHERE pdp_pages.id = pdp_pages_text.item AND pdp_pages_text.language = '$lang' AND pdp_pages.active = 1 ORDER BY razeni");
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
// if not set page icon use page title
$ikona_tmp = printSqlCol('icon',$zaznam);
$pages_arr[$zaznam['pid']] = $ikona_tmp!='' ? $ikona_tmp : printSqlCol('name',$zaznam);
$pages_title_arr[$zaznam['pid']] = printSqlCol('name',$zaznam);
$pages_url_arr[$zaznam['pid']] = $root.$language_link.printSqlCol('alias',$zaznam);
// prepare perex
if ($zaznam['pid']==$page_izolace_id || $zaznam['pid']==$page_filtrace_id || $zaznam['pid']==1) {
$pages_perex_arr[$zaznam['pid']] = strip_tags(printSqlCol('preview',$zaznam));
} else {
$tmp = strip_tags(printSqlCol('preview',$zaznam)).' '.strip_tags(printSqlCol('content',$zaznam));
$pages_perex_arr[$zaznam['pid']] = utf8_substr_word($tmp,160).'...';
}
// if this page == current -> set page type
if ($zaznam['pid']==$page_404_id) {
$p404_text = printSqlCol('content',$zaznam);
$p404obrazky = printSqlCol('images',$zaznam);
$p404soubory = printSqlCol('files',$zaznam);
$p404realforms = printSqlCol('realforms',$zaznam);
}
// products based on pages (category)
if ($zaznam['parentpage']==2 || $zaznam['parentpage']==3 || $zaznam['parentpage']==4 || $zaznam['parentpage']==9) {
$products_page_images_arr[$zaznam['pid']] = printSqlCol('images',$zaznam);
$products_page_cat_arr[$zaznam['pid']] = printSqlCol('parentpage',$zaznam);
// count main products
if (printSqlCol('parentpage',$zaznam)==3) {
$products_izolace_count++;
} else if (printSqlCol('parentpage',$zaznam)==2) {
$products_filtrace_count++;
}
// images
$tmp_arr = explode('|',printSqlCol('images',$zaznam));
$products_page_images_all_arr[] = $tmp_arr[0];
$products_page_images_arr[$zaznam['pid']] = $tmp_arr[0];
}
// if set, add link to this page as subpage
$pages_top_arr[$zaznam['pid']] = printSqlCol('parentpage',$zaznam);
// if this page == current -> set page type
if ($table == 'pdp_pages_text' && $zaznam['pid']==$page_id) {
$page_type = '';
$page_top = printSqlCol('parentpage',$zaznam);
if (isset($pages_top_arr[$page_top]) && $pages_top_arr[$page_top]>0) $page_top = $pages_top_arr[$page_top];
if (!$title) $title = printSqlCol('name',$zaznam);
$perex = printSqlCol('preview',$zaznam);
$text = printSqlCol('content',$zaznam);
$obrazky = printSqlCol('images',$zaznam);
$soubory = printSqlCol('files',$zaznam);
$realforms = printSqlCol('realforms',$zaznam);
$produkt_prodejci = printSqlCol('sellers',$zaznam);
// article products
$produkty_arr = array();
if (printSqlCol('relatedprod',$zaznam)!='') $produkty_arr = explode('|',printSqlCol('relatedprod',$zaznam));
}
}
// product
if ($table == 'pdp_products_text') {
$vysledek = Pg_Exec("SELECT
pdp_products.code,
pdp_products.cat AS cat2,
pdp_products.sellers,
pdp_products.accessoriesprod,
pdp_products.relatedprod,
pdp_products.novinkado,
pdp_products.doporucujeme,
pdp_products.realforms,
pdp_products.id AS pid,
pdp_products.producer,
pdp_products.files,
pdp_products.images,
pdp_products.url,
pdp_products.prislusenstvi,
pdp_products_text.*
FROM pdp_products,pdp_products_text WHERE pdp_products.id = pdp_products_text.item AND pdp_products_text.language = '$lang' AND pdp_products.$sql_active AND pdp_products.id = '$page_id' ORDER BY id DESC LIMIT 20");
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
// main data
$produkt = $title = printSqlCol('name',$zaznam);
$produkt_url = $root.$language_link.printSqlCol('alias',$zaznam);
$produkt_kategorie = printSqlCol('cat2',$zaznam);
// product data
$produkt_kod = printSqlCol('code',$zaznam);
$produkt_eshop = printSqlCol('url',$zaznam);
$produkt_novinkado = printSqlCol('novinkado',$zaznam);
$produkt_doporucujeme = printSqlCol('doporucujeme',$zaznam);
$produkt_realforms = printSqlCol('realforms',$zaznam);
$produkt_prodejci = printSqlCol('sellers',$zaznam);
$produkt_prislusenstvi_init = printSqlCol('prislusenstvi',$zaznam);
$produkt_vyrobce = printSqlCol('producer',$zaznam);
$produkt_perex = $perex = printSqlCol('preview',$zaznam);
$produkt_text = $text = printSqlCol('content',$zaznam);
$produkt_spec = printSqlCol('spec',$zaznam);
// product array
$obrazky = printSqlCol('images',$zaznam);
$soubory = printSqlCol('files',$zaznam);
$prislusenstvi = printSqlCol('accessoriesprod',$zaznam);
$podobne = printSqlCol('relatedprod',$zaznam);
}
}
// article
if ($table == 'pdp_articles_text') {
$vysledek = Pg_Exec("SELECT pdp_articles.expires,pdp_articles.realforms,pdp_articles.sellers,pdp_articles.relatedprod,pdp_articles.id AS pid,pdp_articles.files,pdp_articles.images,pdp_articles_text.* FROM pdp_articles,pdp_articles_text WHERE pdp_articles.id = pdp_articles_text.item AND pdp_articles_text.language = '$lang' AND pdp_articles.$sql_active AND pdp_articles.id = '$page_id'");
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
// main data
$clanek = $title = printSqlCol('name',$zaznam);
$clanek_url = $root.$language_link.printSqlCol('alias',$zaznam);
// article data
$clanek_prodejci = printSqlCol('sellers',$zaznam);
$clanek_perex = $perex = printSqlCol('preview',$zaznam);
$clanek_text = $text = printSqlCol('content',$zaznam);
$realforms = printSqlCol('realforms',$zaznam);
$produkt_prodejci = printSqlCol('sellers',$zaznam);
$clanek_expires = printSqlCol('expires',$zaznam);
// article files
$obrazky = printSqlCol('images',$zaznam);
$soubory = printSqlCol('files',$zaznam);
// article products
$clanek_produkty_arr = array();
if (printSqlCol('relatedprod',$zaznam)!='') $clanek_produkty_arr = explode('|',printSqlCol('relatedprod',$zaznam));
}
}
}
// 404 error page
if (!$page) {
$table = 'pdp_pages_text';
$page_id = $page_404_id;
$title = $pages_arr[$page_id];
$perex = $pages_perex_arr[$page_id];
$text = $p404_text;
$produkty_arr = array();
$obrazky = $p404obrazky;
$soubory = $p404soubory;
$realforms = $p404realforms;
$produkt_prodejci = '';
$breadcrumb = $title;
}
// sellers for pages,news,actions
if ($produkt_prodejci && ($table == 'pdp_pages_text' || $table == 'pdp_articles_text')) {
$produkt_prodejci_arr = explode('|',$produkt_prodejci);
if (count($produkt_prodejci_arr)>0) {
// sql
$sellers_sql = '';
$sellers_sql = 'id='.implode(' OR id=',$produkt_prodejci_arr);
$sellers_sql = ' AND ('.$sellers_sql.')';
//id,name,mail,phone,cz,sk
$vysledek = Pg_Exec("SELECT * FROM pdp_products_sellers WHERE $sql_active$sellers_sql");
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
$sellers_arr[$zaznam['id']] = ''.printSqlCol('name',$zaznam)."
\n".$telefon_text.': '.printSqlCol('phone',$zaznam)."
\n"."\n"; // .$email_text.': '.''.printSqlCol('mail',$zaznam).''
}
}
}
// news
$news = $table=='aktuality' || $page_id==$page_news_id ? true : false;
// folder
$inc_str = '';
// validate send form
if ($get_e && $table == 'pdp_pages_text' && $page_id==251) {
$data_formulare = $predmet = $email_to_bp = '';
$get_e = addslashes($get_e);
$vysledek = Pg_Exec("SELECT * FROM tmp_emails WHERE code='$get_e' AND status='0'");
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
$data_formulare = printSqlCol('content',$zaznam);
$predmet = printSqlCol('title',$zaznam);
$email_formulare = printSqlCol('email',$zaznam);
$email_to_bp = printSqlCol('emailtobp',$zaznam) ? printSqlCol('emailtobp',$zaznam) : 'info@hobra.cz';
}
// insert data to tmp table
if ($data_formulare) {
$sendcommand = "UPDATE tmp_emails SET status=1 WHERE code='$get_e' AND status='0'";
if (Pg_Exec($sendcommand)) {
// petr.vrestiak@gmail.com,
if(Mail("web.hobra@gmail.com",'Hobra Školník / '.$predmet,preg_replace_callback('/([0-9a-fx]+);/mi', 'replace_num_entity', html_entity_decode(stripslashes($data_formulare))),"From: $email_formulare\nContent-type:text/plain; charset=\"utf-8\"\nX-Mailer:PHP/" . phpversion())) {
// print success info
$odesilaci_hlaska = 'Děkujeme, Váš požadavek byl potvrzen a odeslán ke zpracování.';
$odesilaci_hlaska_typ = "correct";
}
} else {
$odesilaci_hlaska = 'Nepodařilo se potvrdit dotaz.
';
}
}
}
// send contact form
$odesilaci_hlaska = false;
$jmeno = $email = $dotaz = '';
$aspm = isset($_POST['aspm']) && $_POST['aspm']!='' ? $_POST['aspm'] : false;
if ($aspm) {
// RESERVATION start
$jmeno = GetOrPostSafe('jmeno','post','str');
$prijmeni = GetOrPostSafe('prijmeni','post','str');
$dotaz = GetOrPostSafe('dotaz','post','str');
$email = GetOrPostSafe('email','post','str');
$telefon = GetOrPostSafe('telefon','post','str');
$izolace = GetOrPostSafe('izolace','post','str');
$filtrace = GetOrPostSafe('filtrace','post','str');
// anti spam
$my_code = 11 * SubStr(GetEnv('REMOTE_ADDR'),0,1);
if(isset($_POST['akce']) && $_POST['akce'] == 'sendForm' && $aspm==$my_code) {
// mail to first contact person
$init = true;
$email_to_bp = '';
if (isset($_POST['seller']) && $_POST['seller']>0) {
$sendSellerID = GetOrPostSafe('seller','post','int');
$vysledek = Pg_Exec("SELECT mail FROM pdp_products_sellers WHERE id=$sendSellerID AND mail IS NOT NULL AND active=1");
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
$email_to_bp = printSqlCol('mail',$zaznam);
if ($email_to_bp) $init = false;
}
} else if (isset($produkt_prodejci_arr) && count($produkt_prodejci_arr)>0) {
foreach ($produkt_prodejci_arr as $key => $value) {
if ($init && $value>0) {
// get first contact email
$lang_sql = " AND $lang = 1";
$vysledek = Pg_Exec("SELECT mail FROM pdp_products_sellers WHERE id=$value AND mail IS NOT NULL AND active=1$lang_sql");
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
$email_to_bp = printSqlCol('mail',$zaznam);
if ($email_to_bp) $init = false;
}
}
}
}
// global customer email nefunguje detekce mailu z db
if ($email_to_bp=='') {
$email_to_bp = 'info@hobra.cz';
}
// if not send requiure data & print error
if ( $email==$email_text || $dotaz==$dotaz_text || $jmeno==$jmeno_text) {
$neodesilat = 'oki';
$odesilaci_hlaska = $odeslano_nok_text;
// email must by valid for send confirmation url
} else if (!CheckEmail($email)) {
$neodesilat = 'oki';
$odesilaci_hlaska = $odeslano_nok_text;
} else {
$adresat1 = '...';
$adresat2 = 'petr.vrestiak@gmail.com';
$dnesni_datum = date("H:i m.d.y");
$predmet = 'Hobra Školník / dotaz ze stránek';
$odesilaci_email = $email_to_bp; // OLD GLOBAL MAIL 'info@hobra.'.$lang;
// mail tmp id
$mail_id = 1;
/*
$mail_id = Pg_Exec("SELECT nextval('tmp_emails_id_seq');");
$mail_id = Pg_Fetch_Array($mail_id,0);
$mail_id = $mail_id['nextval'];
*/
// hash key for email validation
$mail_key = md5(time().$mail_id);
$url_formulare = $_SERVER['REQUEST_URI'];
// make email
$potvrzeni_formulare = '';
/*"
Dobrý den,
děkujeme za Vás dotaz a prosíme o potvrzení níže uvedených údajů, kliknutím na tento odkaz:
http://www.hobra.cz/potvrzeni-zaslaneho-dotazu?e=".$mail_key."
Vzhledem k platné legislativě nemůžeme bez kliknutí na potvrzující odkaz váš dotaz zpracovat.
Děkujeme za pochopení
Hobra s.r.o.
Zde jsou Vaše kontaktní údaje a připravený dotaz:
--------------------------------------------------------------";
*/
$data_formulare = "
$jmeno_text: $jmeno
$email_text: $email
Oblast: $izolace $filtrace
--------------------------------------------------------------
$vas_dotaz_text: $dotaz
Ze stránky: $url_formulare";
}
// insert data to tmp table
if ($data_formulare) {
/*
$sendcommand = "INSERT INTO tmp_emails (id,datumzadani,emailtobp,content,title,email,url,status,code,lang) VALUES (";
$sendcommand .= "'".AddSlashes($mail_id)."',";
$sendcommand .= "CURRENT_TIMESTAMP,";
$sendcommand .= "'".AddSlashes($email_to_bp)."',";
$sendcommand .= "'".AddSlashes($data_formulare)."',";
$sendcommand .= "'".AddSlashes($title)."',";
$sendcommand .= "'".AddSlashes($email)."','".AddSlashes($url_formulare)."',0,'".AddSlashes($mail_key)."','".AddSlashes($lang)."')";
$sendcommand = str_replace("''","NULL",$sendcommand);
*/
//if (Pg_Exec($sendcommand)) {
/*
old sender email new seller email
$odesilaci_email
*/
//
if(Mail('web.hobra@gmail.com',$predmet,$potvrzeni_formulare.preg_replace_callback('/([0-9a-fx]+);/mi', 'replace_num_entity', html_entity_decode(stripslashes($data_formulare))),"From: $email_to_bp\nContent-type:text/plain; charset=\"utf-8\"\nX-Mailer:PHP/" . phpversion())) {
//Mail($email_to_bp,$predmet,$potvrzeni_formulare.preg_replace_callback('/([0-9a-fx]+);/mi', 'replace_num_entity', html_entity_decode(stripslashes($data_formulare))),"From: $email_to_bp\nContent-type:text/plain; charset=\"utf-8\"\nX-Mailer:PHP/" . phpversion())
// DOCASNE!!! - bez kontroly
//Mail('petr.vrestiak@gmail.com',$predmet,$potvrzeni_formulare.preg_replace_callback('/([0-9a-fx]+);/mi', 'replace_num_entity', html_entity_decode(stripslashes($data_formulare))),"From: $email_to_bp\nContent-type:text/plain; charset=\"utf-8\"\nX-Mailer:PHP/" . phpversion())
// print success info
$odesilaci_hlaska = $odeslano_ok_text;
$odesilaci_hlaska_typ = "correct";
} else {
// print error info
$odesilaci_hlaska = $odeslano_nok_text;
}
// clear contacts
$jmeno = $email = $dotaz = '';
/*
} else {
$odesilaci_hlaska = $odeslano_nok_text;
}
*/
}
}
}
$page_section = $table=='pdp_products_cat_text' ? '' : '';
// detect main class 'izolace', 'filtrace', 'other'
$main_class = 'other';
$top_page_title = '';
// clasic pages
if ($table == 'pdp_pages_text') {
// filtrace
if ($page_id==45 || (isset($pages_top_arr[$page_id]) && $pages_top_arr[$page_id]==45) || $page_id==$page_filtrace_id || (isset($pages_top_arr[$page_id]) && $pages_top_arr[$page_id]==$page_filtrace_id) || $page_id==$page_aplication_filtrace_id || (isset($pages_top_arr[$page_id]) && $pages_top_arr[$page_id]==$page_aplication_filtrace_id)) {
$main_class = 'filtrace';
}
// izolace
if ($page_id==$page_izolace_id || (isset($pages_top_arr[$page_id]) && $pages_top_arr[$page_id]==$page_izolace_id) || $page_id==$page_aplication_izolace_id || (isset($pages_top_arr[$page_id]) && $pages_top_arr[$page_id]==$page_aplication_izolace_id)) {
$main_class = 'izolace';
}
// breadcrumb
// 1.st level
$breadcrumb = $top_page_title = $title;
$tmp_breadcrumb = false;
// 2.st level
if (isset($pages_top_arr[$page_id]) && $pages_top_arr[$page_id]>0) {
$tmp_breadcrumb = $pages_top_arr[$page_id];
$breadcrumb = ''.$pages_arr[$pages_top_arr[$page_id]].' > '.$breadcrumb.'';
$top_page_title = $pages_title_arr[$pages_top_arr[$page_id]];
}
// 3.st level
if (isset($pages_top_arr[$tmp_breadcrumb]) && $pages_top_arr[$tmp_breadcrumb]>0) {
$tmp_breadcrumb = $pages_top_arr[$tmp_breadcrumb];
$breadcrumb = ''.$pages_arr[$tmp_breadcrumb].' > '.$breadcrumb;
$top_page_title = $pages_title_arr[$tmp_breadcrumb];
}
// 4.st level
if (isset($pages_top_arr[$tmp_breadcrumb]) && $pages_top_arr[$tmp_breadcrumb]>0) {
$tmp_breadcrumb = $pages_top_arr[$tmp_breadcrumb];
$breadcrumb = ''.$pages_arr[$tmp_breadcrumb].' > '.$breadcrumb;
$top_page_title = $pages_title_arr[$tmp_breadcrumb];
}
} else if ($table == 'pdp_products_text') {
// breadcrumb
$cat_id = $produkt_kategorie;
// filtrace
if ($cat_id==$page_filtrace_id || (isset($pages_top_arr[$cat_id]) && $pages_top_arr[$cat_id]==$page_filtrace_id)) {
$main_class = 'filtrace';
}
// izolace
if ($cat_id==$page_izolace_id || (isset($pages_top_arr[$cat_id]) && $pages_top_arr[$cat_id]==$page_izolace_id)) {
$main_class = 'izolace';
}
// 1.st level
$breadcrumb = $top_page_title = $title;
$tmp_breadcrumb = false;
/*
echo $cat_id.' / ';
print_r($pages_arr);
print_r($pages_top_arr);
*/
// 2.st level
if (isset($pages_arr[$cat_id]) && $pages_arr[$cat_id]) {
$tmp_breadcrumb = $cat_id;
$breadcrumb = ''.$pages_arr[$cat_id].' > '.$breadcrumb.'';
$top_page_title = $pages_title_arr[$cat_id];
}
// 3.st level
if (isset($pages_top_arr[$tmp_breadcrumb]) && $pages_top_arr[$tmp_breadcrumb]>0) {
$tmp_breadcrumb = $pages_top_arr[$tmp_breadcrumb];
$breadcrumb = ''.$pages_arr[$tmp_breadcrumb].' > '.$breadcrumb;
$top_page_title = $pages_title_arr[$tmp_breadcrumb];
}
// 4.st level
if (isset($pages_top_arr[$tmp_breadcrumb]) && $pages_top_arr[$tmp_breadcrumb]>0) {
$tmp_breadcrumb = $pages_top_arr[$tmp_breadcrumb];
$breadcrumb = ''.$pages_arr[$tmp_breadcrumb].' > '.$breadcrumb;
$top_page_title = $pages_title_arr[$tmp_breadcrumb];
}
}
/*
-----------------
all banners
-----------------
*/
$banners_left_arr = $banners_slideshow_arr = $banners_url_arr = $banners_pcs_arr = $banners_type_arr = $banners_text_arr = $banners_typ_arr = array();
$today = date('Y-m-d');
$banners_folder = $root.'data/banners/';
$banners_first = false;
$vysledek = Pg_Exec("SELECT pdp_banners.typ,pdp_banners.izolace,pdp_banners.filtrace,pdp_banners.ofirme,pdp_banners.soubor,pdp_banners.id,pdp_banners_text.content,pdp_banners_text.preview,pdp_banners_text.name,pdp_banners_text.link FROM pdp_banners,pdp_banners_text WHERE pdp_banners.id = pdp_banners_text.item AND pdp_banners_text.language = '$lang' AND pdp_banners.active = 1 AND pdp_banners.datumod <= '$today' AND pdp_banners.datumdo >= '$today' ORDER BY pdp_banners.razeni");
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
if (($zaznam['izolace']=='t' && $main_class=='izolace') || ($zaznam['filtrace']=='t' && $main_class=='filtrace') || ($zaznam['ofirme']=='t' && $main_class=='other')) {
$banners_slideshow_arr[$zaznam['id']] = printSqlCol('name',$zaznam);
$banners_typ_arr[$zaznam['id']] = printSqlCol('typ',$zaznam);
$banners_url_arr[$zaznam['id']] = printSqlCol('link',$zaznam);
$banners_pcs_arr[$zaznam['id']] = printSqlCol('soubor',$zaznam);
$banners_text_arr[$zaznam['id']] = nl2br(printSqlCol('preview',$zaznam));
// cilovky
if ($zaznam['ofirme']=='t') $banners_color_arr[$zaznam['id']] = 'other';
if ($zaznam['izolace']=='t') $banners_color_arr[$zaznam['id']] = 'izolace';
if ($zaznam['filtrace']=='t') $banners_color_arr[$zaznam['id']] = 'filtrace';
}
}
/*
-----------------
news
-----------------
*/
$news_arr = $news_text_arr = $news_color_arr = $news_foto_arr = $news_foto_all_arr = array();
$vysledek = Pg_Exec("SELECT pdp_articles.*,pdp_articles_text.name,pdp_articles_text.content,pdp_articles_text.alias FROM pdp_articles,pdp_articles_text WHERE pdp_articles.id = pdp_articles_text.item AND pdp_articles_text.language = '$lang' AND pdp_articles.active = 1 AND expires IS NULL ORDER BY pdp_articles.id DESC");
while ($zaznam = Pg_Fetch_Assoc($vysledek)) {
$news_arr[$zaznam['id']] = printSqlCol('name',$zaznam);
$news_text_arr[$zaznam['id']] = printSqlCol('content',$zaznam);
if (printSqlCol('images',$zaznam)) {
$tmp_arr = explode('|',printSqlCol('images',$zaznam));
$news_foto_arr[$zaznam['id']] = $tmp_arr[0];
$news_foto_all_arr[] = $tmp_arr[0];
}
// cilovky
if ($zaznam['ofirme']=='t') $news_color_arr[$zaznam['id']] = 'other';
if ($zaznam['izolace']=='t') $news_color_arr[$zaznam['id']] = 'izolace';
if ($zaznam['filtrace']=='t') $news_color_arr[$zaznam['id']] = 'filtrace';
}
?>
echo $odesilaci_hlaska ?>
// all aplications
foreach ($pages_top_arr as $key => $value) {
if ($value==$page_aplication_filtrace_id) {
?>
echo $pages_title_arr[$key] ?> if ($key==10 || $key==12 || $key==13) { echo ', '; } else { echo '
'; } ?>
}
} ?>
// all aplications
foreach ($pages_top_arr as $key => $value) {
if ($value==$page_aplication_izolace_id) {
?>
echo $pages_title_arr[$key] ?>
}
} ?>
} ?>
echo $main_class=='izolace' ? $pages_perex_arr[$page_izolace_id] : ($main_class=='filtrace' ? $pages_perex_arr[$page_filtrace_id] : $pages_perex_arr[1]) ?>
echo strip_tags($news_text_arr[$key]) ?>
echo $vice_text ?> >
echo $perex ?>
} ?>echo $text ?> echo $hledanemu_vyrazu_text ?> echo $sr ?> echo $odpovida_text ?> echo $nalezeno ?> echo $nalezeno>4 || $nalezeno===0 ? $zaznamu_text : ($nalezeno>1 ? $zaznamy_text : $zaznam_text) ?>.
echo $produkty_perex_arr[$key] ?>
} // list articles foreach ($articles_search_arr as $key => $value) { $i++; ?>echo $articles_search_perex_arr[$key] ?>
} // list pages foreach ($pages_search_arr as $key => $value) { $i++; ?>echo $pages_search_perex_arr[$key] ?>
} /* ---------------------------------- APLICATIONS (search) ---------------------------------- */ } else if ($table=='pdp_pages_text' && ($page_top==$page_aplication_izolace_id || $page_top==$page_aplication_filtrace_id)) { // archive images $file_name_arr = $filepath_arr = $filepath_big_arr = $image_rec_title_arr = array(); $first_img = false; if ($obrazky!='') { $tmp_arr = $pcs_order_arr = explode('|',$obrazky); GetImagesArr($tmp_arr); // update img. arr. $first_img = isset($filepath_big_arr[$tmp_arr[0]]) ? $filepath_big_arr[$tmp_arr[0]] : false; $first_title_img = isset($image_rec_title_arr[0]) ? $image_rec_title_arr[0] : ''; } ?>echo $perex ?>
} ?> echo $text ?> // content files $downloads_arr = array(); if ($soubory!='') { $tmp_arr = explode('|',$soubory); GetFilesArr($tmp_arr); if (count($downloads_arr)>0) { ?>
echo $downloads_text ?>:
// list next images
foreach ($downloads_arr as $key => $value) {
?>
echo $value ?>
} ?>
echo $products_perex_arr[$key] ?>
echo $aplikace_text ?>:
// aplications
$n = 0;
if (isset($products_application_arr[$key]) && count($products_application_arr[$key])>0) {
foreach ($products_application_arr[$key] as $key2 => $value2) {
$n++;
?>
echo $pages_arr[$value2] ?> if ($n
echo $perex ?>
} ?> echo $text ?> // content files $downloads_arr = array(); if ($soubory!='') { $tmp_arr = explode('|',$soubory); GetFilesArr($tmp_arr); if (count($downloads_arr)>0) { ?>
echo $downloads_text ?>:
// list next images
foreach ($downloads_arr as $key => $value) {
?>
echo $value ?>
} ?>
echo $pages_perex_arr[$key] ?>
} } // end page products // start list regular products // archive images $file_name_arr = $filepath_arr = $filepath_big_arr = $image_rec_title_arr = array(); // read all products photos GetImagesArr($products_foto_all_arr); // img arr foreach ($products_cat_arr as $key => $value) { //produkt_pcs_arr if ($value==$page_id) { $i++; $m++; ?>echo $products_perex_arr[$key] ?>
echo $aplikace_text ?>:
// aplications
$n = 0;
if (isset($products_application_arr[$key]) && count($products_application_arr[$key])>0) {
foreach ($products_application_arr[$key] as $key2 => $value2) {
$n++;
?>
echo $pages_arr[$value2] ?> if ($n
echo $perex ?>
} ?> echo $text ?>echo $perex ?>
} ?> echo $text ?> // content files $downloads_arr = array(); if ($soubory!='') { $tmp_arr = explode('|',$soubory); GetFilesArr($tmp_arr); if (count($downloads_arr)>0) { ?>
echo $downloads_text ?>:
// list next images
foreach ($downloads_arr as $key => $value) {
?>
echo $value ?>
} ?>
echo $aplikace_text ?>:
// aplications
if (isset($products_application_arr[$page_id]) && count($products_application_arr[$page_id])>0) {
foreach ($products_application_arr[$page_id] as $key => $value) {
?>
echo $pages_arr[$value] ?>
}
} ?>
echo $perex_pr ?>
} ?> echo $text_pr ?> // content files $downloads_arr = array(); if ($soubory!='') { $tmp_arr = explode('|',$soubory); GetFilesArr($tmp_arr); if (count($downloads_arr)>0) { ?>
echo $downloads_text ?>:
// list next images
foreach ($downloads_arr as $key => $value) {
?>
echo $value ?>
} ?>
echo $perex ?>
} ?> echo $text ?> // conacts if ($produkt_prodejci!='') { $tmp_arr = explode('|',$produkt_prodejci); echo ''; echo PrintContacts($tmp_arr); } ?> // content files $downloads_arr = array(); if ($soubory!='') { $tmp_arr = explode('|',$soubory); GetFilesArr($tmp_arr); if (count($downloads_arr)>0) { ?>
echo $downloads_text ?>:
// list next images
foreach ($downloads_arr as $key => $value) {
?>
echo $value ?>
} ?>